<?php 
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2007 osCommerce

  Released under the GNU General Public License
*/

  include('includes/application_top.php');

  $zone_id = $_POST['zone_id'];
  $cqy = tep_db_query("select city_id, city_name from " . TABLE_CITIES . " where city_zone_id = '" . $zone_id . "' order by city_name asc");
  if (tep_db_num_rows($cqy) == 0) {
              echo '<option value="0">'. htmlentities(ENTRY_ANY_CITY).'</option>';
        } else {
            while ($cv = tep_db_fetch_array($cqy)) {
              echo '<option value="' . $cv['city_id'] . '">' . $cv['city_name'] . '</option>';
            }
        }

  require(DIR_WS_INCLUDES . 'application_bottom.php');
?>